package com.example.es02.DO;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class SnnDistExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SnnDistExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andDistCodeIsNull() {
            addCriterion("dist_code is null");
            return (Criteria) this;
        }

        public Criteria andDistCodeIsNotNull() {
            addCriterion("dist_code is not null");
            return (Criteria) this;
        }

        public Criteria andDistCodeEqualTo(String value) {
            addCriterion("dist_code =", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeNotEqualTo(String value) {
            addCriterion("dist_code <>", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeGreaterThan(String value) {
            addCriterion("dist_code >", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeGreaterThanOrEqualTo(String value) {
            addCriterion("dist_code >=", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeLessThan(String value) {
            addCriterion("dist_code <", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeLessThanOrEqualTo(String value) {
            addCriterion("dist_code <=", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeLike(String value) {
            addCriterion("dist_code like", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeNotLike(String value) {
            addCriterion("dist_code not like", value, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeIn(List<String> values) {
            addCriterion("dist_code in", values, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeNotIn(List<String> values) {
            addCriterion("dist_code not in", values, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeBetween(String value1, String value2) {
            addCriterion("dist_code between", value1, value2, "distCode");
            return (Criteria) this;
        }

        public Criteria andDistCodeNotBetween(String value1, String value2) {
            addCriterion("dist_code not between", value1, value2, "distCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeIsNull() {
            addCriterion("sys_org_code is null");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeIsNotNull() {
            addCriterion("sys_org_code is not null");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeEqualTo(String value) {
            addCriterion("sys_org_code =", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeNotEqualTo(String value) {
            addCriterion("sys_org_code <>", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeGreaterThan(String value) {
            addCriterion("sys_org_code >", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sys_org_code >=", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeLessThan(String value) {
            addCriterion("sys_org_code <", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("sys_org_code <=", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeLike(String value) {
            addCriterion("sys_org_code like", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeNotLike(String value) {
            addCriterion("sys_org_code not like", value, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeIn(List<String> values) {
            addCriterion("sys_org_code in", values, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeNotIn(List<String> values) {
            addCriterion("sys_org_code not in", values, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeBetween(String value1, String value2) {
            addCriterion("sys_org_code between", value1, value2, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andSysOrgCodeNotBetween(String value1, String value2) {
            addCriterion("sys_org_code not between", value1, value2, "sysOrgCode");
            return (Criteria) this;
        }

        public Criteria andDistNameIsNull() {
            addCriterion("dist_name is null");
            return (Criteria) this;
        }

        public Criteria andDistNameIsNotNull() {
            addCriterion("dist_name is not null");
            return (Criteria) this;
        }

        public Criteria andDistNameEqualTo(String value) {
            addCriterion("dist_name =", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameNotEqualTo(String value) {
            addCriterion("dist_name <>", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameGreaterThan(String value) {
            addCriterion("dist_name >", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameGreaterThanOrEqualTo(String value) {
            addCriterion("dist_name >=", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameLessThan(String value) {
            addCriterion("dist_name <", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameLessThanOrEqualTo(String value) {
            addCriterion("dist_name <=", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameLike(String value) {
            addCriterion("dist_name like", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameNotLike(String value) {
            addCriterion("dist_name not like", value, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameIn(List<String> values) {
            addCriterion("dist_name in", values, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameNotIn(List<String> values) {
            addCriterion("dist_name not in", values, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameBetween(String value1, String value2) {
            addCriterion("dist_name between", value1, value2, "distName");
            return (Criteria) this;
        }

        public Criteria andDistNameNotBetween(String value1, String value2) {
            addCriterion("dist_name not between", value1, value2, "distName");
            return (Criteria) this;
        }

        public Criteria andCreditCodeIsNull() {
            addCriterion("credit_code is null");
            return (Criteria) this;
        }

        public Criteria andCreditCodeIsNotNull() {
            addCriterion("credit_code is not null");
            return (Criteria) this;
        }

        public Criteria andCreditCodeEqualTo(String value) {
            addCriterion("credit_code =", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeNotEqualTo(String value) {
            addCriterion("credit_code <>", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeGreaterThan(String value) {
            addCriterion("credit_code >", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeGreaterThanOrEqualTo(String value) {
            addCriterion("credit_code >=", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeLessThan(String value) {
            addCriterion("credit_code <", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeLessThanOrEqualTo(String value) {
            addCriterion("credit_code <=", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeLike(String value) {
            addCriterion("credit_code like", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeNotLike(String value) {
            addCriterion("credit_code not like", value, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeIn(List<String> values) {
            addCriterion("credit_code in", values, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeNotIn(List<String> values) {
            addCriterion("credit_code not in", values, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeBetween(String value1, String value2) {
            addCriterion("credit_code between", value1, value2, "creditCode");
            return (Criteria) this;
        }

        public Criteria andCreditCodeNotBetween(String value1, String value2) {
            addCriterion("credit_code not between", value1, value2, "creditCode");
            return (Criteria) this;
        }

        public Criteria andDistNameCnIsNull() {
            addCriterion("dist_name_cn is null");
            return (Criteria) this;
        }

        public Criteria andDistNameCnIsNotNull() {
            addCriterion("dist_name_cn is not null");
            return (Criteria) this;
        }

        public Criteria andDistNameCnEqualTo(String value) {
            addCriterion("dist_name_cn =", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnNotEqualTo(String value) {
            addCriterion("dist_name_cn <>", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnGreaterThan(String value) {
            addCriterion("dist_name_cn >", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnGreaterThanOrEqualTo(String value) {
            addCriterion("dist_name_cn >=", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnLessThan(String value) {
            addCriterion("dist_name_cn <", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnLessThanOrEqualTo(String value) {
            addCriterion("dist_name_cn <=", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnLike(String value) {
            addCriterion("dist_name_cn like", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnNotLike(String value) {
            addCriterion("dist_name_cn not like", value, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnIn(List<String> values) {
            addCriterion("dist_name_cn in", values, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnNotIn(List<String> values) {
            addCriterion("dist_name_cn not in", values, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnBetween(String value1, String value2) {
            addCriterion("dist_name_cn between", value1, value2, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameCnNotBetween(String value1, String value2) {
            addCriterion("dist_name_cn not between", value1, value2, "distNameCn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnIsNull() {
            addCriterion("dist_name_en is null");
            return (Criteria) this;
        }

        public Criteria andDistNameEnIsNotNull() {
            addCriterion("dist_name_en is not null");
            return (Criteria) this;
        }

        public Criteria andDistNameEnEqualTo(String value) {
            addCriterion("dist_name_en =", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnNotEqualTo(String value) {
            addCriterion("dist_name_en <>", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnGreaterThan(String value) {
            addCriterion("dist_name_en >", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnGreaterThanOrEqualTo(String value) {
            addCriterion("dist_name_en >=", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnLessThan(String value) {
            addCriterion("dist_name_en <", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnLessThanOrEqualTo(String value) {
            addCriterion("dist_name_en <=", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnLike(String value) {
            addCriterion("dist_name_en like", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnNotLike(String value) {
            addCriterion("dist_name_en not like", value, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnIn(List<String> values) {
            addCriterion("dist_name_en in", values, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnNotIn(List<String> values) {
            addCriterion("dist_name_en not in", values, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnBetween(String value1, String value2) {
            addCriterion("dist_name_en between", value1, value2, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andDistNameEnNotBetween(String value1, String value2) {
            addCriterion("dist_name_en not between", value1, value2, "distNameEn");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andZipCodeIsNull() {
            addCriterion("zip_code is null");
            return (Criteria) this;
        }

        public Criteria andZipCodeIsNotNull() {
            addCriterion("zip_code is not null");
            return (Criteria) this;
        }

        public Criteria andZipCodeEqualTo(String value) {
            addCriterion("zip_code =", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeNotEqualTo(String value) {
            addCriterion("zip_code <>", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeGreaterThan(String value) {
            addCriterion("zip_code >", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeGreaterThanOrEqualTo(String value) {
            addCriterion("zip_code >=", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeLessThan(String value) {
            addCriterion("zip_code <", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeLessThanOrEqualTo(String value) {
            addCriterion("zip_code <=", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeLike(String value) {
            addCriterion("zip_code like", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeNotLike(String value) {
            addCriterion("zip_code not like", value, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeIn(List<String> values) {
            addCriterion("zip_code in", values, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeNotIn(List<String> values) {
            addCriterion("zip_code not in", values, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeBetween(String value1, String value2) {
            addCriterion("zip_code between", value1, value2, "zipCode");
            return (Criteria) this;
        }

        public Criteria andZipCodeNotBetween(String value1, String value2) {
            addCriterion("zip_code not between", value1, value2, "zipCode");
            return (Criteria) this;
        }

        public Criteria andContactPhoneIsNull() {
            addCriterion("contact_phone is null");
            return (Criteria) this;
        }

        public Criteria andContactPhoneIsNotNull() {
            addCriterion("contact_phone is not null");
            return (Criteria) this;
        }

        public Criteria andContactPhoneEqualTo(String value) {
            addCriterion("contact_phone =", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotEqualTo(String value) {
            addCriterion("contact_phone <>", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneGreaterThan(String value) {
            addCriterion("contact_phone >", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("contact_phone >=", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneLessThan(String value) {
            addCriterion("contact_phone <", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneLessThanOrEqualTo(String value) {
            addCriterion("contact_phone <=", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneLike(String value) {
            addCriterion("contact_phone like", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotLike(String value) {
            addCriterion("contact_phone not like", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneIn(List<String> values) {
            addCriterion("contact_phone in", values, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotIn(List<String> values) {
            addCriterion("contact_phone not in", values, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneBetween(String value1, String value2) {
            addCriterion("contact_phone between", value1, value2, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotBetween(String value1, String value2) {
            addCriterion("contact_phone not between", value1, value2, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactsIsNull() {
            addCriterion("contacts is null");
            return (Criteria) this;
        }

        public Criteria andContactsIsNotNull() {
            addCriterion("contacts is not null");
            return (Criteria) this;
        }

        public Criteria andContactsEqualTo(String value) {
            addCriterion("contacts =", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotEqualTo(String value) {
            addCriterion("contacts <>", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThan(String value) {
            addCriterion("contacts >", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThanOrEqualTo(String value) {
            addCriterion("contacts >=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThan(String value) {
            addCriterion("contacts <", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThanOrEqualTo(String value) {
            addCriterion("contacts <=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLike(String value) {
            addCriterion("contacts like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotLike(String value) {
            addCriterion("contacts not like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsIn(List<String> values) {
            addCriterion("contacts in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotIn(List<String> values) {
            addCriterion("contacts not in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsBetween(String value1, String value2) {
            addCriterion("contacts between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotBetween(String value1, String value2) {
            addCriterion("contacts not between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeIsNull() {
            addCriterion("dist_group_code is null");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeIsNotNull() {
            addCriterion("dist_group_code is not null");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeEqualTo(String value) {
            addCriterion("dist_group_code =", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeNotEqualTo(String value) {
            addCriterion("dist_group_code <>", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeGreaterThan(String value) {
            addCriterion("dist_group_code >", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeGreaterThanOrEqualTo(String value) {
            addCriterion("dist_group_code >=", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeLessThan(String value) {
            addCriterion("dist_group_code <", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeLessThanOrEqualTo(String value) {
            addCriterion("dist_group_code <=", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeLike(String value) {
            addCriterion("dist_group_code like", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeNotLike(String value) {
            addCriterion("dist_group_code not like", value, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeIn(List<String> values) {
            addCriterion("dist_group_code in", values, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeNotIn(List<String> values) {
            addCriterion("dist_group_code not in", values, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeBetween(String value1, String value2) {
            addCriterion("dist_group_code between", value1, value2, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistGroupCodeNotBetween(String value1, String value2) {
            addCriterion("dist_group_code not between", value1, value2, "distGroupCode");
            return (Criteria) this;
        }

        public Criteria andDistTypeIsNull() {
            addCriterion("dist_type is null");
            return (Criteria) this;
        }

        public Criteria andDistTypeIsNotNull() {
            addCriterion("dist_type is not null");
            return (Criteria) this;
        }

        public Criteria andDistTypeEqualTo(String value) {
            addCriterion("dist_type =", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeNotEqualTo(String value) {
            addCriterion("dist_type <>", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeGreaterThan(String value) {
            addCriterion("dist_type >", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeGreaterThanOrEqualTo(String value) {
            addCriterion("dist_type >=", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeLessThan(String value) {
            addCriterion("dist_type <", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeLessThanOrEqualTo(String value) {
            addCriterion("dist_type <=", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeLike(String value) {
            addCriterion("dist_type like", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeNotLike(String value) {
            addCriterion("dist_type not like", value, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeIn(List<String> values) {
            addCriterion("dist_type in", values, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeNotIn(List<String> values) {
            addCriterion("dist_type not in", values, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeBetween(String value1, String value2) {
            addCriterion("dist_type between", value1, value2, "distType");
            return (Criteria) this;
        }

        public Criteria andDistTypeNotBetween(String value1, String value2) {
            addCriterion("dist_type not between", value1, value2, "distType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeIsNull() {
            addCriterion("cooperation_type is null");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeIsNotNull() {
            addCriterion("cooperation_type is not null");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeEqualTo(String value) {
            addCriterion("cooperation_type =", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeNotEqualTo(String value) {
            addCriterion("cooperation_type <>", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeGreaterThan(String value) {
            addCriterion("cooperation_type >", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeGreaterThanOrEqualTo(String value) {
            addCriterion("cooperation_type >=", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeLessThan(String value) {
            addCriterion("cooperation_type <", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeLessThanOrEqualTo(String value) {
            addCriterion("cooperation_type <=", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeLike(String value) {
            addCriterion("cooperation_type like", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeNotLike(String value) {
            addCriterion("cooperation_type not like", value, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeIn(List<String> values) {
            addCriterion("cooperation_type in", values, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeNotIn(List<String> values) {
            addCriterion("cooperation_type not in", values, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeBetween(String value1, String value2) {
            addCriterion("cooperation_type between", value1, value2, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andCooperationTypeNotBetween(String value1, String value2) {
            addCriterion("cooperation_type not between", value1, value2, "cooperationType");
            return (Criteria) this;
        }

        public Criteria andSimsCodeIsNull() {
            addCriterion("sims_code is null");
            return (Criteria) this;
        }

        public Criteria andSimsCodeIsNotNull() {
            addCriterion("sims_code is not null");
            return (Criteria) this;
        }

        public Criteria andSimsCodeEqualTo(String value) {
            addCriterion("sims_code =", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeNotEqualTo(String value) {
            addCriterion("sims_code <>", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeGreaterThan(String value) {
            addCriterion("sims_code >", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sims_code >=", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeLessThan(String value) {
            addCriterion("sims_code <", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeLessThanOrEqualTo(String value) {
            addCriterion("sims_code <=", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeLike(String value) {
            addCriterion("sims_code like", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeNotLike(String value) {
            addCriterion("sims_code not like", value, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeIn(List<String> values) {
            addCriterion("sims_code in", values, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeNotIn(List<String> values) {
            addCriterion("sims_code not in", values, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeBetween(String value1, String value2) {
            addCriterion("sims_code between", value1, value2, "simsCode");
            return (Criteria) this;
        }

        public Criteria andSimsCodeNotBetween(String value1, String value2) {
            addCriterion("sims_code not between", value1, value2, "simsCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeIsNull() {
            addCriterion("business_code is null");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeIsNotNull() {
            addCriterion("business_code is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeEqualTo(String value) {
            addCriterion("business_code =", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotEqualTo(String value) {
            addCriterion("business_code <>", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeGreaterThan(String value) {
            addCriterion("business_code >", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeGreaterThanOrEqualTo(String value) {
            addCriterion("business_code >=", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeLessThan(String value) {
            addCriterion("business_code <", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeLessThanOrEqualTo(String value) {
            addCriterion("business_code <=", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeLike(String value) {
            addCriterion("business_code like", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotLike(String value) {
            addCriterion("business_code not like", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeIn(List<String> values) {
            addCriterion("business_code in", values, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotIn(List<String> values) {
            addCriterion("business_code not in", values, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeBetween(String value1, String value2) {
            addCriterion("business_code between", value1, value2, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotBetween(String value1, String value2) {
            addCriterion("business_code not between", value1, value2, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBooleanDdIsNull() {
            addCriterion("boolean_DD is null");
            return (Criteria) this;
        }

        public Criteria andBooleanDdIsNotNull() {
            addCriterion("boolean_DD is not null");
            return (Criteria) this;
        }

        public Criteria andBooleanDdEqualTo(String value) {
            addCriterion("boolean_DD =", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdNotEqualTo(String value) {
            addCriterion("boolean_DD <>", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdGreaterThan(String value) {
            addCriterion("boolean_DD >", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdGreaterThanOrEqualTo(String value) {
            addCriterion("boolean_DD >=", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdLessThan(String value) {
            addCriterion("boolean_DD <", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdLessThanOrEqualTo(String value) {
            addCriterion("boolean_DD <=", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdLike(String value) {
            addCriterion("boolean_DD like", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdNotLike(String value) {
            addCriterion("boolean_DD not like", value, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdIn(List<String> values) {
            addCriterion("boolean_DD in", values, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdNotIn(List<String> values) {
            addCriterion("boolean_DD not in", values, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdBetween(String value1, String value2) {
            addCriterion("boolean_DD between", value1, value2, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andBooleanDdNotBetween(String value1, String value2) {
            addCriterion("boolean_DD not between", value1, value2, "booleanDd");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateIsNull() {
            addCriterion("dd_begin_date is null");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateIsNotNull() {
            addCriterion("dd_begin_date is not null");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateEqualTo(Date value) {
            addCriterion("dd_begin_date =", value, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateNotEqualTo(Date value) {
            addCriterion("dd_begin_date <>", value, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateGreaterThan(Date value) {
            addCriterion("dd_begin_date >", value, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateGreaterThanOrEqualTo(Date value) {
            addCriterion("dd_begin_date >=", value, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateLessThan(Date value) {
            addCriterion("dd_begin_date <", value, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateLessThanOrEqualTo(Date value) {
            addCriterion("dd_begin_date <=", value, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateIn(List<Date> values) {
            addCriterion("dd_begin_date in", values, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateNotIn(List<Date> values) {
            addCriterion("dd_begin_date not in", values, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateBetween(Date value1, Date value2) {
            addCriterion("dd_begin_date between", value1, value2, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdBeginDateNotBetween(Date value1, Date value2) {
            addCriterion("dd_begin_date not between", value1, value2, "ddBeginDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateIsNull() {
            addCriterion("dd_end_date is null");
            return (Criteria) this;
        }

        public Criteria andDdEndDateIsNotNull() {
            addCriterion("dd_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andDdEndDateEqualTo(Date value) {
            addCriterion("dd_end_date =", value, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateNotEqualTo(Date value) {
            addCriterion("dd_end_date <>", value, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateGreaterThan(Date value) {
            addCriterion("dd_end_date >", value, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateGreaterThanOrEqualTo(Date value) {
            addCriterion("dd_end_date >=", value, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateLessThan(Date value) {
            addCriterion("dd_end_date <", value, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateLessThanOrEqualTo(Date value) {
            addCriterion("dd_end_date <=", value, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateIn(List<Date> values) {
            addCriterion("dd_end_date in", values, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateNotIn(List<Date> values) {
            addCriterion("dd_end_date not in", values, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateBetween(Date value1, Date value2) {
            addCriterion("dd_end_date between", value1, value2, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andDdEndDateNotBetween(Date value1, Date value2) {
            addCriterion("dd_end_date not between", value1, value2, "ddEndDate");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("create_by like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("create_by not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("update_by like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("update_by not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1IsNull() {
            addCriterion("qualification_pic1 is null");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1IsNotNull() {
            addCriterion("qualification_pic1 is not null");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1EqualTo(String value) {
            addCriterion("qualification_pic1 =", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1NotEqualTo(String value) {
            addCriterion("qualification_pic1 <>", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1GreaterThan(String value) {
            addCriterion("qualification_pic1 >", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1GreaterThanOrEqualTo(String value) {
            addCriterion("qualification_pic1 >=", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1LessThan(String value) {
            addCriterion("qualification_pic1 <", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1LessThanOrEqualTo(String value) {
            addCriterion("qualification_pic1 <=", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1Like(String value) {
            addCriterion("qualification_pic1 like", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1NotLike(String value) {
            addCriterion("qualification_pic1 not like", value, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1In(List<String> values) {
            addCriterion("qualification_pic1 in", values, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1NotIn(List<String> values) {
            addCriterion("qualification_pic1 not in", values, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1Between(String value1, String value2) {
            addCriterion("qualification_pic1 between", value1, value2, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic1NotBetween(String value1, String value2) {
            addCriterion("qualification_pic1 not between", value1, value2, "qualificationPic1");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2IsNull() {
            addCriterion("qualification_pic2 is null");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2IsNotNull() {
            addCriterion("qualification_pic2 is not null");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2EqualTo(String value) {
            addCriterion("qualification_pic2 =", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2NotEqualTo(String value) {
            addCriterion("qualification_pic2 <>", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2GreaterThan(String value) {
            addCriterion("qualification_pic2 >", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2GreaterThanOrEqualTo(String value) {
            addCriterion("qualification_pic2 >=", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2LessThan(String value) {
            addCriterion("qualification_pic2 <", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2LessThanOrEqualTo(String value) {
            addCriterion("qualification_pic2 <=", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2Like(String value) {
            addCriterion("qualification_pic2 like", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2NotLike(String value) {
            addCriterion("qualification_pic2 not like", value, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2In(List<String> values) {
            addCriterion("qualification_pic2 in", values, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2NotIn(List<String> values) {
            addCriterion("qualification_pic2 not in", values, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2Between(String value1, String value2) {
            addCriterion("qualification_pic2 between", value1, value2, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic2NotBetween(String value1, String value2) {
            addCriterion("qualification_pic2 not between", value1, value2, "qualificationPic2");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3IsNull() {
            addCriterion("qualification_pic3 is null");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3IsNotNull() {
            addCriterion("qualification_pic3 is not null");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3EqualTo(String value) {
            addCriterion("qualification_pic3 =", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3NotEqualTo(String value) {
            addCriterion("qualification_pic3 <>", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3GreaterThan(String value) {
            addCriterion("qualification_pic3 >", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3GreaterThanOrEqualTo(String value) {
            addCriterion("qualification_pic3 >=", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3LessThan(String value) {
            addCriterion("qualification_pic3 <", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3LessThanOrEqualTo(String value) {
            addCriterion("qualification_pic3 <=", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3Like(String value) {
            addCriterion("qualification_pic3 like", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3NotLike(String value) {
            addCriterion("qualification_pic3 not like", value, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3In(List<String> values) {
            addCriterion("qualification_pic3 in", values, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3NotIn(List<String> values) {
            addCriterion("qualification_pic3 not in", values, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3Between(String value1, String value2) {
            addCriterion("qualification_pic3 between", value1, value2, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andQualificationPic3NotBetween(String value1, String value2) {
            addCriterion("qualification_pic3 not between", value1, value2, "qualificationPic3");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagIsNull() {
            addCriterion("delete_flag is null");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagIsNotNull() {
            addCriterion("delete_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagEqualTo(Integer value) {
            addCriterion("delete_flag =", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagNotEqualTo(Integer value) {
            addCriterion("delete_flag <>", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagGreaterThan(Integer value) {
            addCriterion("delete_flag >", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("delete_flag >=", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagLessThan(Integer value) {
            addCriterion("delete_flag <", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagLessThanOrEqualTo(Integer value) {
            addCriterion("delete_flag <=", value, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagIn(List<Integer> values) {
            addCriterion("delete_flag in", values, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagNotIn(List<Integer> values) {
            addCriterion("delete_flag not in", values, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagBetween(Integer value1, Integer value2) {
            addCriterion("delete_flag between", value1, value2, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andDeleteFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("delete_flag not between", value1, value2, "deleteFlag");
            return (Criteria) this;
        }

        public Criteria andRegionCodeIsNull() {
            addCriterion("region_code is null");
            return (Criteria) this;
        }

        public Criteria andRegionCodeIsNotNull() {
            addCriterion("region_code is not null");
            return (Criteria) this;
        }

        public Criteria andRegionCodeEqualTo(String value) {
            addCriterion("region_code =", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotEqualTo(String value) {
            addCriterion("region_code <>", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeGreaterThan(String value) {
            addCriterion("region_code >", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeGreaterThanOrEqualTo(String value) {
            addCriterion("region_code >=", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeLessThan(String value) {
            addCriterion("region_code <", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeLessThanOrEqualTo(String value) {
            addCriterion("region_code <=", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeLike(String value) {
            addCriterion("region_code like", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotLike(String value) {
            addCriterion("region_code not like", value, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeIn(List<String> values) {
            addCriterion("region_code in", values, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotIn(List<String> values) {
            addCriterion("region_code not in", values, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeBetween(String value1, String value2) {
            addCriterion("region_code between", value1, value2, "regionCode");
            return (Criteria) this;
        }

        public Criteria andRegionCodeNotBetween(String value1, String value2) {
            addCriterion("region_code not between", value1, value2, "regionCode");
            return (Criteria) this;
        }

        public Criteria andContactEmailIsNull() {
            addCriterion("contact_email is null");
            return (Criteria) this;
        }

        public Criteria andContactEmailIsNotNull() {
            addCriterion("contact_email is not null");
            return (Criteria) this;
        }

        public Criteria andContactEmailEqualTo(String value) {
            addCriterion("contact_email =", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailNotEqualTo(String value) {
            addCriterion("contact_email <>", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailGreaterThan(String value) {
            addCriterion("contact_email >", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailGreaterThanOrEqualTo(String value) {
            addCriterion("contact_email >=", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailLessThan(String value) {
            addCriterion("contact_email <", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailLessThanOrEqualTo(String value) {
            addCriterion("contact_email <=", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailLike(String value) {
            addCriterion("contact_email like", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailNotLike(String value) {
            addCriterion("contact_email not like", value, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailIn(List<String> values) {
            addCriterion("contact_email in", values, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailNotIn(List<String> values) {
            addCriterion("contact_email not in", values, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailBetween(String value1, String value2) {
            addCriterion("contact_email between", value1, value2, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andContactEmailNotBetween(String value1, String value2) {
            addCriterion("contact_email not between", value1, value2, "contactEmail");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNull() {
            addCriterion("tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNotNull() {
            addCriterion("tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualTo(Integer value) {
            addCriterion("tax_rate =", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualTo(Integer value) {
            addCriterion("tax_rate <>", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThan(Integer value) {
            addCriterion("tax_rate >", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualTo(Integer value) {
            addCriterion("tax_rate >=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThan(Integer value) {
            addCriterion("tax_rate <", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualTo(Integer value) {
            addCriterion("tax_rate <=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateIn(List<Integer> values) {
            addCriterion("tax_rate in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotIn(List<Integer> values) {
            addCriterion("tax_rate not in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateBetween(Integer value1, Integer value2) {
            addCriterion("tax_rate between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotBetween(Integer value1, Integer value2) {
            addCriterion("tax_rate not between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitIsNull() {
            addCriterion("product_notify_limmit is null");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitIsNotNull() {
            addCriterion("product_notify_limmit is not null");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitEqualTo(Integer value) {
            addCriterion("product_notify_limmit =", value, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitNotEqualTo(Integer value) {
            addCriterion("product_notify_limmit <>", value, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitGreaterThan(Integer value) {
            addCriterion("product_notify_limmit >", value, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitGreaterThanOrEqualTo(Integer value) {
            addCriterion("product_notify_limmit >=", value, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitLessThan(Integer value) {
            addCriterion("product_notify_limmit <", value, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitLessThanOrEqualTo(Integer value) {
            addCriterion("product_notify_limmit <=", value, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitIn(List<Integer> values) {
            addCriterion("product_notify_limmit in", values, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitNotIn(List<Integer> values) {
            addCriterion("product_notify_limmit not in", values, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitBetween(Integer value1, Integer value2) {
            addCriterion("product_notify_limmit between", value1, value2, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andProductNotifyLimmitNotBetween(Integer value1, Integer value2) {
            addCriterion("product_notify_limmit not between", value1, value2, "productNotifyLimmit");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndIsNull() {
            addCriterion("effective_end is null");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndIsNotNull() {
            addCriterion("effective_end is not null");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndEqualTo(Date value) {
            addCriterionForJDBCDate("effective_end =", value, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndNotEqualTo(Date value) {
            addCriterionForJDBCDate("effective_end <>", value, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndGreaterThan(Date value) {
            addCriterionForJDBCDate("effective_end >", value, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("effective_end >=", value, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndLessThan(Date value) {
            addCriterionForJDBCDate("effective_end <", value, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("effective_end <=", value, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndIn(List<Date> values) {
            addCriterionForJDBCDate("effective_end in", values, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndNotIn(List<Date> values) {
            addCriterionForJDBCDate("effective_end not in", values, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("effective_end between", value1, value2, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andEffectiveEndNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("effective_end not between", value1, value2, "effectiveEnd");
            return (Criteria) this;
        }

        public Criteria andContactWechatIsNull() {
            addCriterion("contact_wechat is null");
            return (Criteria) this;
        }

        public Criteria andContactWechatIsNotNull() {
            addCriterion("contact_wechat is not null");
            return (Criteria) this;
        }

        public Criteria andContactWechatEqualTo(String value) {
            addCriterion("contact_wechat =", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatNotEqualTo(String value) {
            addCriterion("contact_wechat <>", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatGreaterThan(String value) {
            addCriterion("contact_wechat >", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatGreaterThanOrEqualTo(String value) {
            addCriterion("contact_wechat >=", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatLessThan(String value) {
            addCriterion("contact_wechat <", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatLessThanOrEqualTo(String value) {
            addCriterion("contact_wechat <=", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatLike(String value) {
            addCriterion("contact_wechat like", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatNotLike(String value) {
            addCriterion("contact_wechat not like", value, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatIn(List<String> values) {
            addCriterion("contact_wechat in", values, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatNotIn(List<String> values) {
            addCriterion("contact_wechat not in", values, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatBetween(String value1, String value2) {
            addCriterion("contact_wechat between", value1, value2, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andContactWechatNotBetween(String value1, String value2) {
            addCriterion("contact_wechat not between", value1, value2, "contactWechat");
            return (Criteria) this;
        }

        public Criteria andUsedNameIsNull() {
            addCriterion("used_name is null");
            return (Criteria) this;
        }

        public Criteria andUsedNameIsNotNull() {
            addCriterion("used_name is not null");
            return (Criteria) this;
        }

        public Criteria andUsedNameEqualTo(String value) {
            addCriterion("used_name =", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameNotEqualTo(String value) {
            addCriterion("used_name <>", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameGreaterThan(String value) {
            addCriterion("used_name >", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameGreaterThanOrEqualTo(String value) {
            addCriterion("used_name >=", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameLessThan(String value) {
            addCriterion("used_name <", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameLessThanOrEqualTo(String value) {
            addCriterion("used_name <=", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameLike(String value) {
            addCriterion("used_name like", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameNotLike(String value) {
            addCriterion("used_name not like", value, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameIn(List<String> values) {
            addCriterion("used_name in", values, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameNotIn(List<String> values) {
            addCriterion("used_name not in", values, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameBetween(String value1, String value2) {
            addCriterion("used_name between", value1, value2, "usedName");
            return (Criteria) this;
        }

        public Criteria andUsedNameNotBetween(String value1, String value2) {
            addCriterion("used_name not between", value1, value2, "usedName");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagIsNull() {
            addCriterion("online_flag is null");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagIsNotNull() {
            addCriterion("online_flag is not null");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagEqualTo(String value) {
            addCriterion("online_flag =", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagNotEqualTo(String value) {
            addCriterion("online_flag <>", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagGreaterThan(String value) {
            addCriterion("online_flag >", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagGreaterThanOrEqualTo(String value) {
            addCriterion("online_flag >=", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagLessThan(String value) {
            addCriterion("online_flag <", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagLessThanOrEqualTo(String value) {
            addCriterion("online_flag <=", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagLike(String value) {
            addCriterion("online_flag like", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagNotLike(String value) {
            addCriterion("online_flag not like", value, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagIn(List<String> values) {
            addCriterion("online_flag in", values, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagNotIn(List<String> values) {
            addCriterion("online_flag not in", values, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagBetween(String value1, String value2) {
            addCriterion("online_flag between", value1, value2, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andOnlineFlagNotBetween(String value1, String value2) {
            addCriterion("online_flag not between", value1, value2, "onlineFlag");
            return (Criteria) this;
        }

        public Criteria andAliasIsNull() {
            addCriterion("alias is null");
            return (Criteria) this;
        }

        public Criteria andAliasIsNotNull() {
            addCriterion("alias is not null");
            return (Criteria) this;
        }

        public Criteria andAliasEqualTo(String value) {
            addCriterion("alias =", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotEqualTo(String value) {
            addCriterion("alias <>", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasGreaterThan(String value) {
            addCriterion("alias >", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasGreaterThanOrEqualTo(String value) {
            addCriterion("alias >=", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLessThan(String value) {
            addCriterion("alias <", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLessThanOrEqualTo(String value) {
            addCriterion("alias <=", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLike(String value) {
            addCriterion("alias like", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotLike(String value) {
            addCriterion("alias not like", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasIn(List<String> values) {
            addCriterion("alias in", values, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotIn(List<String> values) {
            addCriterion("alias not in", values, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasBetween(String value1, String value2) {
            addCriterion("alias between", value1, value2, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotBetween(String value1, String value2) {
            addCriterion("alias not between", value1, value2, "alias");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}